Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountID (FK)(PK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | CustomerAccount(LE_CTAC) |
PaymentAccountSequence (PK) | A sequence number to distinguish between payment accounts tied to a CustomerAccount. A value of 1 is always used to indicate the PRIMARY, default account. | AI_PYM_ACNT_SQN | LineNumber | smallint | |
CreditDeibitCardTypeCode | A code denoting which kind of card is being accepted. Sample values include: DEBIT CREDIT EBT FLEET OTHER | TY_CRD | Code6 | char(6) | |
CardIssuerCode | The first six digits from the Credit/Debit card. It identifies the bank or other financial institution that issued the debit/credit card used in the transaction. | ID_ISSR_TND_CRD | Code6 | char(6) | |
AccountNumber | The account number appearing on a debit/credit card and identifying the card issuer's customer account to be charged or credited for the transaction. This information must be encrypted. | ID_ACNT_DB_CR_CRD | Name | varchar(40) | |
Track1CreditCardBitMap | Defines the bit pattern used on track 1 of the magnetic strip on the back of a credit card. | DE_TRCK_1_BT_MP | BitMap | binary(128) | |
Track2CreditCardBitMap | Defines the bit pattern used on track 2 of the magnetic strip on the back of a credit card. | DE_TRCK_2_BT_MP | BitMap | binary(128) | |
Track3CreditCardBitMap | Defines the bit pattern used on track 3 of the magnetic strip on the back of a credit card. | DE_TRCK_3_BT | BitMap | binary(128) | |
Track4CreditCardBitMap | Defines the bit pattern used on track 4 of the magnetic strip on the back of a credit card. | BM_CR_CRD_TRK_4 | BitMap | binary(128) | |
CardExpirationDate | The expiration date of the Credit or Debit card, as taken from the card in MMYY format. | DC_EP_CRD | Code4 | char(4) | |
CardHolderName | The name of the cardholder, as taken from the card. | NM_CRD_HLD | Name | varchar(40) | |
CardIssuerSequenceNumber | The IssueSequnce number of the credit card being used assigned by the Credit/Debit Card issuer. | AI_CRD_ISS | Identity | integer | |
CardStartDate | The commencement date of the Credit or Debit card, as taken from the card in MMYY format. | DT_CRD_SRT | Code4 | char(4) | |
ServiceCode | The value of the service field from the card. In XML this is referred to as a SecurityCode. The names vary from one credit debit card provider to another. Both are the same thing - a 3-4 digit code used to validate a card at the POS. | CD_SV | Code4 | char(4) | |
ReconciliationCode | A code used to indicate if thie credit/debit card instance is reconciled or not. | CD_RCN | Identity | integer | |
StatusCode | Indiates the status of this designated customer account payment account. Valid values are: A - Active N - Activated but not used C - Canceled S - Suspended | CD_STS | Code2Status | char(2) | |
EffectiveDate | The date an EncryptedCustomerAccountPaymentAccount becomes active. | DC_EF_DT | EffectiveDateTime | datetime | |
ExpirationDate | The date an EncryptedCustomerAccountPaymentAccount becomes inactive. | DC_EP_DT | ExpirationDate | date | |